pip install --upgrade pip
Requirement already satisfied: pip in c:\users\par20\anaconda3\lib\site-packages (21.0.1)
Collecting pip
Downloading pip-22.3-py3-none-any.whl (2.1 MB)
Installing collected packages: pip
Attempting uninstall: pip
Found existing installation: pip 21.0.1
Uninstalling pip-21.0.1:
Successfully uninstalled pip-21.0.1
Successfully installed pip-22.3
Note: you may need to restart the kernel to use updated packages.
pip install Pandas-Profiling
Collecting Pandas-Profiling
Downloading pandas_profiling-3.3.0-py2.py3-none-any.whl (268 kB)
-------------------------------------- 268.0/268.0 kB 4.2 MB/s eta 0:00:00
Requirement already satisfied: matplotlib<3.6,>=3.2 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (3.3.4)
Collecting joblib~=1.1.0
Downloading joblib-1.1.1-py2.py3-none-any.whl (309 kB)
-------------------------------------- 309.8/309.8 kB 4.8 MB/s eta 0:00:00
Requirement already satisfied: pandas!=1.4.0,<1.5,>1.1 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (1.2.4)
Collecting htmlmin==0.1.12
Downloading htmlmin-0.1.12.tar.gz (19 kB)
Preparing metadata (setup.py): started
Preparing metadata (setup.py): finished with status 'done'
Collecting tangled-up-in-unicode==0.2.0
Downloading tangled_up_in_unicode-0.2.0-py3-none-any.whl (4.7 MB)
---------------------------------------- 4.7/4.7 MB 5.2 MB/s eta 0:00:00
Collecting missingno<0.6,>=0.4.2
Downloading missingno-0.5.1-py3-none-any.whl (8.7 kB)
Requirement already satisfied: seaborn<0.12,>=0.10.1 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (0.11.1)
Requirement already satisfied: tqdm<4.65,>=4.48.2 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (4.59.0)
Collecting pydantic<1.10,>=1.8.1
Downloading pydantic-1.9.2-cp38-cp38-win_amd64.whl (2.1 MB)
---------------------------------------- 2.1/2.1 MB 5.0 MB/s eta 0:00:00
Collecting multimethod<1.9,>=1.4
Downloading multimethod-1.8-py3-none-any.whl (9.8 kB)
Requirement already satisfied: requests<2.29,>=2.24.0 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (2.25.1)
Requirement already satisfied: jinja2<3.2,>=2.11.1 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (2.11.3)
Collecting visions[type_image_path]==0.7.5
Downloading visions-0.7.5-py3-none-any.whl (102 kB)
-------------------------------------- 102.7/102.7 kB 6.2 MB/s eta 0:00:00
Collecting phik<0.13,>=0.11.1
Downloading phik-0.12.2-cp38-cp38-win_amd64.whl (677 kB)
-------------------------------------- 677.3/677.3 kB 4.8 MB/s eta 0:00:00
Collecting statsmodels<0.14,>=0.13.2
Downloading statsmodels-0.13.2-cp38-cp38-win_amd64.whl (9.1 MB)
---------------------------------------- 9.1/9.1 MB 5.1 MB/s eta 0:00:00
Requirement already satisfied: scipy<1.10,>=1.4.1 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (1.6.2)
Requirement already satisfied: PyYAML<6.1,>=5.0.0 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (5.4.1)
Requirement already satisfied: numpy<1.24,>=1.16.0 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (1.20.1)
Requirement already satisfied: networkx>=2.4 in c:\users\par20\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->Pandas-Profiling) (2.5)
Requirement already satisfied: attrs>=19.3.0 in c:\users\par20\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->Pandas-Profiling) (20.3.0)
Collecting imagehash
Downloading ImageHash-4.3.1-py2.py3-none-any.whl (296 kB)
-------------------------------------- 296.5/296.5 kB 2.3 MB/s eta 0:00:00
Requirement already satisfied: Pillow in c:\users\par20\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->Pandas-Profiling) (8.2.0)
Requirement already satisfied: MarkupSafe>=0.23 in c:\users\par20\anaconda3\lib\site-packages (from jinja2<3.2,>=2.11.1->Pandas-Profiling) (1.1.1)
Requirement already satisfied: kiwisolver>=1.0.1 in c:\users\par20\anaconda3\lib\site-packages (from matplotlib<3.6,>=3.2->Pandas-Profiling) (1.3.1)
Requirement already satisfied: cycler>=0.10 in c:\users\par20\anaconda3\lib\site-packages (from matplotlib<3.6,>=3.2->Pandas-Profiling) (0.10.0)
Requirement already satisfied: python-dateutil>=2.1 in c:\users\par20\anaconda3\lib\site-packages (from matplotlib<3.6,>=3.2->Pandas-Profiling) (2.8.1)
Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.3 in c:\users\par20\anaconda3\lib\site-packages (from matplotlib<3.6,>=3.2->Pandas-Profiling) (2.4.7)
Requirement already satisfied: pytz>=2017.3 in c:\users\par20\anaconda3\lib\site-packages (from pandas!=1.4.0,<1.5,>1.1->Pandas-Profiling) (2021.1)
Requirement already satisfied: typing-extensions>=3.7.4.3 in c:\users\par20\anaconda3\lib\site-packages (from pydantic<1.10,>=1.8.1->Pandas-Profiling) (3.7.4.3)
Requirement already satisfied: certifi>=2017.4.17 in c:\users\par20\anaconda3\lib\site-packages (from requests<2.29,>=2.24.0->Pandas-Profiling) (2020.12.5)
Requirement already satisfied: chardet<5,>=3.0.2 in c:\users\par20\anaconda3\lib\site-packages (from requests<2.29,>=2.24.0->Pandas-Profiling) (4.0.0)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\users\par20\anaconda3\lib\site-packages (from requests<2.29,>=2.24.0->Pandas-Profiling) (1.26.4)
Requirement already satisfied: idna<3,>=2.5 in c:\users\par20\anaconda3\lib\site-packages (from requests<2.29,>=2.24.0->Pandas-Profiling) (2.10)
Collecting packaging>=21.3
Downloading packaging-21.3-py3-none-any.whl (40 kB)
---------------------------------------- 40.8/40.8 kB 1.9 MB/s eta 0:00:00
Collecting patsy>=0.5.2
Downloading patsy-0.5.3-py2.py3-none-any.whl (233 kB)
-------------------------------------- 233.8/233.8 kB 2.8 MB/s eta 0:00:00
Requirement already satisfied: six in c:\users\par20\anaconda3\lib\site-packages (from cycler>=0.10->matplotlib<3.6,>=3.2->Pandas-Profiling) (1.15.0)
Requirement already satisfied: decorator>=4.3.0 in c:\users\par20\anaconda3\lib\site-packages (from networkx>=2.4->visions[type_image_path]==0.7.5->Pandas-Profiling) (5.0.6)
Requirement already satisfied: PyWavelets in c:\users\par20\anaconda3\lib\site-packages (from imagehash->visions[type_image_path]==0.7.5->Pandas-Profiling) (1.1.1)
Building wheels for collected packages: htmlmin
Building wheel for htmlmin (setup.py): started
Building wheel for htmlmin (setup.py): finished with status 'done'
Created wheel for htmlmin: filename=htmlmin-0.1.12-py3-none-any.whl size=27085 sha256=cf877cfb86000ae7eab087c0aa30aef0b977fa64327c0ccef9e5c16572441bac
Stored in directory: c:\users\par20\appdata\local\pip\cache\wheels\28\f3\26\826f91b0c848ff98f1725cd43014a6f3a2d961114157d790db
Successfully built htmlmin
Installing collected packages: htmlmin, tangled-up-in-unicode, pydantic, patsy, packaging, multimethod, joblib, imagehash, visions, statsmodels, phik, missingno, Pandas-Profiling
Attempting uninstall: patsy
Found existing installation: patsy 0.5.1
Uninstalling patsy-0.5.1:
Successfully uninstalled patsy-0.5.1
Attempting uninstall: packaging
Found existing installation: packaging 20.9
Uninstalling packaging-20.9:
Successfully uninstalled packaging-20.9
Attempting uninstall: joblib
Found existing installation: joblib 1.0.1
Uninstalling joblib-1.0.1:
Successfully uninstalled joblib-1.0.1
Attempting uninstall: statsmodels
Found existing installation: statsmodels 0.12.2
Uninstalling statsmodels-0.12.2:
Successfully uninstalled statsmodels-0.12.2
Successfully installed Pandas-Profiling-3.3.0 htmlmin-0.1.12 imagehash-4.3.1 joblib-1.1.1 missingno-0.5.1 multimethod-1.8 packaging-21.3 patsy-0.5.3 phik-0.12.2 pydantic-1.9.2 statsmodels-0.13.2 tangled-up-in-unicode-0.2.0 visions-0.7.5
Note: you may need to restart the kernel to use updated packages.
import numpy as np
import pandas as pd
from pandas_profiling import ProfileReport
df_Covid19_patient_impact = pd.read_csv("C:/Users/par20/Downloads/COVID-19_Reported_Patient_Impact_and_Hospital_Capacity_by_Facility.csv")
df_Covid19_patient_impact.head()
| hospital_pk | collection_week | state | ccn | hospital_name | address | city | zip | hospital_subtype | fips_code | ... | previous_day_admission_pediatric_covid_confirmed_unknown_7_day_sum | staffed_icu_pediatric_patients_confirmed_covid_7_day_avg | staffed_icu_pediatric_patients_confirmed_covid_7_day_coverage | staffed_icu_pediatric_patients_confirmed_covid_7_day_sum | staffed_pediatric_icu_bed_occupancy_7_day_avg | staffed_pediatric_icu_bed_occupancy_7_day_coverage | staffed_pediatric_icu_bed_occupancy_7_day_sum | total_staffed_pediatric_icu_beds_7_day_avg | total_staffed_pediatric_icu_beds_7_day_coverage | total_staffed_pediatric_icu_beds_7_day_sum | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 50742 | 2022-09-09 | CA | 50742 | OLYMPIA MEDICAL CENTER | 5900 WEST OLYMPIC BOULEVARD | LOS ANGELES | 90036.0 | Short Term | 6037.0 | ... | NaN | NaN | 0 | NaN | NaN | 0 | NaN | NaN | 0 | NaN |
| 1 | 360362 | 2022-09-09 | OH | 360362 | TRIHEALTH EVENDALE HOSPITAL | 3155 GLENDALE MILFORD ROAD | CINCINNATI | 45241.0 | Short Term | 39061.0 | ... | 0.0 | 0.0 | 7 | 0.0 | 0.0 | 7 | 0.0 | 0.0 | 7 | 0.0 |
| 2 | 50028 | 2022-09-02 | CA | 50028 | MAD RIVER COMMUNITY HOSPITAL | 3800 JANES RD | ARCATA | 95521.0 | Short Term | 6023.0 | ... | NaN | NaN | 0 | NaN | NaN | 0 | NaN | NaN | 0 | NaN |
| 3 | 100106 | 2022-09-02 | FL | 100106 | DOCTORS MEMORIAL HOSPITAL INC | 333 N BYRON BUTLER PKWY | PERRY | 32348.0 | Short Term | 12123.0 | ... | 0.0 | 0.0 | 7 | 0.0 | 0.0 | 7 | 0.0 | 0.0 | 7 | 0.0 |
| 4 | 110190 | 2022-09-02 | GA | 110190 | FLINT RIVER COMMUNITY HOSPITAL | 509 SUMTER STREET, BOX 770 | MONTEZUMA | 31063.0 | Short Term | 13193.0 | ... | 0.0 | 0.0 | 7 | 0.0 | 0.0 | 7 | 0.0 | 0.0 | 7 | 0.0 |
5 rows × 128 columns
profile_minimal = ProfileReport(df_Covid19_patient_impact, title="Pandas Profiling Report", minimal = True)
profile_minimal